package com.atung.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.atung.model.BusSchoolOpenRoute;

@Mapper
public interface BusSchoolOpenRouteDAO {

	/**
	 * 
	 * @param city_id
	 * @return
	 */
	@Select("select * from bus_school_open_route  where departl_id=#{departlId} and destination_city_id=#{destinationCityId} and running_status=0  and is_delect=0")
	List<BusSchoolOpenRoute>selectCarRouteByCityIdAndschoolId(@Param("departlId")Long departlId,@Param("destinationCityId")Long destinationCityId);
}
